You can customize Reporting Services reports using free SQL Server tools:
■ Microsoft SQL Server 2008 R2 Report Builder 3.0
■ SQL Server Business Intelligence Development Studio (BIDS) installs with the SQL Server 2005 Express Edition Toolkit.
To prepare your environment
1. Uninstall any beta or Community Technology Preview (CTP) versions of SQL Server Management Studio Express.
2. Verify you have administrative rights and ample free space on the machine where you will be working with reports: 600 MB for the toolkit.
3. Install Microsoft .NET Framework 4.0.
4. Install your version of Microsoft SQL Server Express Edition.
5. Install your report tool using the links above.
To work with an .RDL in BIDS
1. Create a new Report Server project (File > New > Project > Report Server Project).
2. For the project, create a new Shared Data Source.
□ Name it IMIS.
□ Use Edit… to specify your server and database.
□ Select the Credentials tab to specify your SQL Server login.
3. In the Solution Explorer, right-click Reports, Add / Existing Item, and browse to the .RDL file downloaded from IQA.
4. Edit the report definition, and select Save.
5. Import the report back into the Document System, or use it in a separate SQL Server Reporting Services server environment, as needed.